package com.spm.dao;

import org.apache.ibatis.annotations.Param;

public interface StudentGradeMapper {
    int deleteChooseRecordBySidAndCnoAndTid(@Param("sid")String sid,@Param("cno")String cno,@Param("tid")String tid);

    int insertRecord(@Param("sid")String sid,@Param("tid")String tid,@Param("cno")String cno);

    int updateChooseState(@Param("sid")String sid,@Param("tid")String tid,@Param("cno")String cno);

    int updateDailyGrade(@Param("sid")String sid,@Param("tid")String tid,@Param("cno")String cno,@Param("dailygrade") Integer dailygrade);
    int updateTwoGrades(@Param("sid")String sid,@Param("tid")String tid,@Param("cno")String cno,@Param("dailygrade") Integer dailygrade,@Param("dailygrade") Integer finalgrade);
    int updateFinalGrade(@Param("sid")String sid,@Param("tid")String tid,@Param("cno")String cno,@Param("dailygrade") Integer finalgrade);

}
